//All four rows (without Event Listeners ) created and saved in TT_GUI7.java
//TT_GUI9.java: Draw GUI of Page1 and initialises the CBoxes from database tables.
//TT_GUI10.java: TT_GUI9.java + unsuccessful operations in database + working in cboxes
//TT_GUI11.java: prev + successful operations in database + working in cboxes + consistency assured
// + tf an south for conformation msgs replaced by button+ addTextfieldsToMyInnerPanel() replaced by its definition.
//TT_GUI12.java: fully working but isolated
//TT_GUI13.java: Final Page 1: prev+ func for the page to view page1 and hide page2.
//TT_GUI14.java: prev + check on buttons implemented.
//TT_GUI15.java: prev + column option in CBoxOptions
//TT_GUI16.java: prev + radiobuttons replaced by btn to go to page2 +
// synchronised with Page2(file Page2nd7.java) +
// synchronised with Page2(updated file Page2nd10.java)
//Features coming soon:
//1.)MenuBar
//2.)shows a model dailog to enter the schema user n pass & a new file with some extension,
//say myTT.tt, now all 5 tables names with prefixed by myTT phrase in the schema mentioned.
import java.sql.*;
import java.util.*;
import java.io.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
public class TT_GUI{
public static void main(String[] args){
//myFrame frame;
EventQueue.invokeLater(new Runnable()
{
public void run(){
myFrame frame=new myFrame();
//frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
//frame.setVisible(true);
}
});
}
}
class myFrame extends JFrame{
public static String[] initialOptions( String tname , String cname)//returns first item as -Select param-
{
int noOfRows=0;
qry=new String("select count(*) from "+tname);//Execute queries and/or updates
String[] CBoxOptions = null;
try
{
rset=stmt.executeQuery(qry);
if(rset != null)
while(rset.next())
{
noOfRows = rset.getInt(1);
myFrame.noOfItems = noOfRows;
}
CBoxOptions = new String[noOfRows+1];
qry=new String("select "+cname+" from "+tname);//Execute queries and/or updates
rset=stmt.executeQuery(qry);
CBoxOptions[0] = "-Select "+tname+"-";//"-Select-";//
if(rset != null)
for(int count=1; rset.next(); count++)
{
CBoxOptions[count] = rset.getString(1);
}
}
catch(Exception e)
{
System.out.println("2.)Error in InitialOptions "+e.toString());
}
return (CBoxOptions);
}
myFrame(){
//Frame Details
this.setExtendedState(MAXIMIZED_BOTH);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
setTitle("Administrator Screen, Page1/2");
// setSize(DEFAULT_WIDTH, DEFAULT_HEIGHT);
// setResizable(false);
page1rowTypeA.Page1frame=this;
JdbcConnection myCon = new JdbcConnection();
try
{
Connection con = myCon.conn();//Get a Connection object
stmt = con.createStatement();//Get a Statement object
}
catch(SQLException e)
{
System.out.println("1.)Error in con or stmt "+e.toString());
}
Scanner in = new Scanner(System.in);
mainPanel = new JPanel();//add to borderlayout.centre
mainPanel.setLayout(new GridLayout(6,1));
page1rowTypeA Trow = new page1rowTypeA(mainPanel, "Batch", myFrame.initialOptions("Batch", "id"), 25);
page1rowTypeA Crow = new page1rowTypeA(mainPanel, "Course", myFrame.initialOptions("Course", "id"), 60);
page1rowTypeA Grow = new page1rowTypeA(mainPanel, "Room", myFrame.initialOptions("Room", "id"), 95);
page1rowTypeA Rrow = new page1rowTypeA(mainPanel, "Teacher", myFrame.initialOptions("Teacher", "id"), 130);
mainPanel.add(page1rowTypeA.btnGo);
mainPanel.add(page1rowTypeA.nextPanel);
add(mainPanel, BorderLayout.CENTER);//adds mainPanel to the frame
add(page1rowTypeA.btn_south, BorderLayout.SOUTH);
add(page1rowTypeA.btnHead, BorderLayout.NORTH);
}
public static boolean insert(String itemToInsert, String tName)
{
qry = ("Insert into "+tName+"(id) values('"+itemToInsert+"')");
try{
stmt.executeUpdate(qry);
return (true);
}
catch(SQLException e)
{
System.out.println("Error in static insert() "+e.toString());
return (false);
}
}
public static boolean delete(String itemToDelete, String tName)
{
qry = ("delete from "+tName+" where id = '"+itemToDelete+"'");
try
{
stmt.executeUpdate(qry);
return (true);
}
catch(SQLException e)
{
System.out.println("Error in static delete() "+e.toString());
return (false);
}
}
public static boolean update(String oldItem, String newItem, String tName)
{
qry = ("Update "+tName+" set id = '"+newItem+"' where id = '"+oldItem+"'");
try
{
stmt.executeUpdate(qry);
return (true);
}
catch(SQLException e)
{
System.out.println("Error in static update() "+e.toString());
return (false);
}
}
JPanel mainPanel;
public static int noOfItems;
private static final int DEFAULT_WIDTH = 600;
private static final int DEFAULT_HEIGHT = 400;
static Statement stmt;
static ResultSet rset; // = stmt.executeQuery("select max(studentid) from student");
static String qry;
}
class page1rowTypeA implements ActionListener{
page1rowTypeA(JPanel myPanel, String tName,String[] CBoxOptions, int posY){
this.tName = tName;
JLabel myLabel = new JLabel(tName);
myCBox=new JComboBox(CBoxOptions);
tf1 = new JTextField("Insert "+tName+":");
btnInsert = new JButton("Insert");//Insert
btnUpdate = new JButton("Update");//Update
btnDelete = new JButton("Delete");//Delete
btnInsert.addActionListener(this);
btnUpdate.addActionListener(this);
btnDelete.addActionListener(this);
myInnerPanel.add(tf1);//add tf1 to myInnerPanel
myInnerPanel.add(btnInsert);//add btn to myInnerPanel
myInnerPanel.add(btnUpdate);//add btn to myInnerPanel
myInnerPanel.add(btnDelete);//add btn to myInnerPanel
JPanel OPanel = new JPanel();
OPanel.add(myLabel);// myLabel.setBounds(25, posY, 70, 30);//add faceLabel to OPanel
OPanel.add(myCBox); //myCBox.setBounds(100, posY, 70, 30);//add faceCBox to OPanel
OPanel.add(myInnerPanel);// myInnerPanel.setBounds(175, posY, 70, 30);//add inner panel to OPanel
myPanel.add(OPanel);//add OPanel to myPanel
OPanel.setBounds(25, posY, 40, 300);
}
public void actionPerformed(ActionEvent event)
{
boolean db_status = false;
String btnLabel = event.getActionCommand();
if(btnLabel == "Insert")
{
String itemToInsert = tf1.getText();
if((!itemToInsert.equals("Insert "+tName+":")) && (!itemToInsert.equals("")) && (!(itemToInsert.charAt(0)=='-')))
{
db_status = myFrame.insert(itemToInsert, tName);
if(db_status)
{
myCBox.addItem(itemToInsert);
btn_south.setText(itemToInsert +" inserted..");
}
}
else
btn_south.setText(itemToInsert +" NOT inserted, select appropriate option for "+tName+"..");
}
else if(btnLabel == "Update")
{
String newItem = tf1.getText();
if((myCBox.getSelectedIndex() != -1) && (myCBox.getSelectedIndex() != 0))
{
if((newItem != "Insert "+tName+":") && ((!newItem.equals("-Select-"))))
{
String itemToUpdate = (String)myCBox.getSelectedItem();
db_status = myFrame.update(newItem, itemToUpdate, tName);
if(db_status)
{
myCBox.removeItem(itemToUpdate);
myCBox.addItem(newItem);
btn_south.setText(itemToUpdate+" updated as "+newItem+"..");
}
else
btn_south.setText("Item NOT updated..");
}
}
else
{
btn_south.setText("CAUTION: Select an item from the List to update or insert an appropriate "+tName+"..");
}
}
else if(btnLabel == "Delete")
{
if((myCBox.getSelectedIndex() != -1) && (!myCBox.getSelectedItem().equals("-Select-")))
{
String itemToDelete = (String)myCBox.getSelectedItem();
db_status = myFrame.delete(itemToDelete, tName);
if(db_status)
{
myCBox.removeItem(itemToDelete);
btn_south.setText(itemToDelete+" deleted..");
}
else
btn_south.setText(itemToDelete +" NOT deleted..");
}
else
{
btn_south.setText("CAUTION: Select an item from the List to delete..");
}
}
}
static void addBtnPage2()//final String tableName, String label)
{
nextPanel.add(btnPage2);
btnPage2.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent event)
{
page1rowTypeA.page2 = new Page2nd();
(page1rowTypeA.Page1frame).setVisible(false);
}
}
);
}
static void viewPage1(){//page1rowTypeA.viewPage1()
page2.setVisible(false);
Page1frame.setVisible(true);
}
static JPanel nextPanel;
static JButton btnGo = new JButton("Select the parameter by which you would like to generate TimeTable : ");
static JButton btnPage2 = new JButton("Schedule Timetable");
JComboBox myCBox;
static JButton btnHead = new JButton("Welcome to TimeTable Software");
String tName;
static JButton btn_south;
protected JPanel myInnerPanel = new JPanel();
JButton btnInsert;
JButton btnUpdate;
JButton btnDelete;
JTextField tf1;
static myFrame Page1frame;
static Page2nd page2;
static
{
btn_south = new JButton("Welcome");
btn_south.setEnabled(false);
nextPanel = new JPanel();
page1rowTypeA.addBtnPage2();
btnHead.setEnabled(false);
btnGo.setEnabled(false);
}
}